﻿ IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'tb_Vendor_Distribution_InspectionResults') 
AND name = N'IDX_Vendor_Dist_InspectionResults')
	DROP INDEX IDX_Vendor_Dist_InspectionResults ON tb_Vendor_Distribution_InspectionResults WITH ( ONLINE = OFF )

CREATE NONCLUSTERED INDEX IDX_Vendor_Dist_InspectionResults ON tb_Vendor_Distribution_InspectionResults
(
	Vendor_Distribution_PoleFk
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


